Prerequisites

The following section describes the prerequisites for working with Qlik Replicate and an ODBC source with CDC.

Replicate server for Windows

You can connect an endpoint to Qlik Replicate using ODBC by indicating the DSN (Data Source Name). In this case you must be sure that a DSN is defined for the ODBC endpoint on the computer where Qlik Replicate is installed.

1. Install an endpoint client on the computer where Qlik Replicate is installed. The client you install depends on the ODBC provider you are using. For example, if you are using an IBM DB2 endpoint, install an IBM DB2 client.

   Information note

   You must use a 64-bit ODBC provider client to work with Qlik Replicate

2. Use the ODBC Data Source Administrator to create a System DSN.The Data Source is located in the Windows control panel.

Replicate server for Linux

The following section describes the steps for working with Qlik Replicate for Linux and ODBC with CDC as a source endpoint in a Replicate task.

1. On the Qlik Replicate Server machine, install the ODBC client that you want to use (e.g. postgreSQL).

2. Makes sure that the /etc/odbcinst.ini file contains the correct entry for the driver you installed, as in the following example:[PostgeSQL]

   Description = ODBC for PostgreSQL

   Driver = /usr/lib/psqlodbc.so

   Setup = /usr/lib/libodbcpsqlS.so

   Driver64 = /usr/lib64/psqlodbc.so

   Setup64 = /usr/lib64/libodbcpsqlS.so

   FileUsage = 1

3. Define a DSN for the installed driver by editing the /etc/odbc.ini file, as in the following example:

   [Postgre_DSN]

   Description = Test

   Driver = /usr/lib64/psqlodbc.so

   Endpoint = MyDatabase

   Servername = 12.3.45.678

   Port = 5432